Error: #NULL! displays due to space used to separate cell references.

Error:


#NULL!

Cause:


A space instead of a comma has been entered to separate cell references that are arguments for functions.

Solution:


Type the correct range operator (comma) between ranges in the formula.
NOTE: NO spaces are accepted in formulas.